﻿CREATE TABLE [dbo].[onco_Schema] (
    [IDSchema]     INT           IDENTITY (1, 1) NOT NULL,
    [IDProtocol]   SMALLINT      NOT NULL,
    [Ziua]         SMALLINT      CONSTRAINT [DF_onco_Schema_Ziua] DEFAULT ((1)) NOT NULL,
    [ZiuaCiclu2]   SMALLINT      NULL,
    [IDCitostatic] SMALLINT      NOT NULL,
    [Doza]         FLOAT (53)    NOT NULL,
    [Explicatie]   VARCHAR (250) CONSTRAINT [DF_onco_Schema_Explicatie2] DEFAULT ('') NOT NULL,
    CONSTRAINT [PK_onco_Schema] PRIMARY KEY CLUSTERED ([IDSchema] ASC),
    CONSTRAINT [FK_onco_Schema_onco_Citostatice] FOREIGN KEY ([IDCitostatic]) REFERENCES [dbo].[onco_Citostatice] ([IDCitostatic]),
    CONSTRAINT [FK_onco_Schema_onco_Protocoale] FOREIGN KEY ([IDProtocol]) REFERENCES [dbo].[onco_Protocoale] ([IDProtocol])
);

